package com.scalar.chiptrack.adaptor.osep;

import com.scalar.chiptrack.adaptor.AdaptorConstants;
import com.scalar.chiptrack.adaptor.AdaptorUtils;
import com.scalar.chiptrack.adaptor.dao.AdaptorRunInfo;
import com.scalar.chiptrack.jobs.JobHandler;
import com.scalar.chiptrack.utils.Logger;
import com.scalar.chiptrack.utils.StringUtils;
import com.scalar.chiptrack.utils.DateUtil;
import com.scalar.chiptrack.users.VendorAdaptor;
import com.scalar.chiptrack.users.dao.AdaptorSetUpDAO;
import com.scalar.ScalarException;

import com.enterprisedt.net.ftp.FTPClient;
import com.enterprisedt.net.ftp.FTPTransferType;
import com.enterprisedt.net.ftp.FTPConnectMode;

import java.io.FileOutputStream;
import java.io.IOException;

/**
 * Created by IntelliJ IDEA.
 * User: Sudhakar
 * Date: Aug 2, 2007
 * Time: 4:37:26 PM
 */
public class OSEPDieBankFTPAdaptor extends JobHandler implements AdaptorConstants
{

    private static final int    PORT            = 21;
    private static final String HOST            = "ftp.ose.com.ph";
    public  static final String ADAPTOR_NAME    = "OSEP_DIE_BANK";
    public  static final String FILE_NAME_WIP   = "I90-YRMPI001";

    private static final String FILE_EXTN_CSV   = ".CSV";
    private static final String HOME_DIR        = "/spectra/";

    private String m_username           = null;
    private String m_password           = null;
    private Logger m_adaptorLogger      = null;
    private String m_dataOutputDir      = null;
    private int    m_adaptor_id     = -1;


    public OSEPDieBankFTPAdaptor() throws Exception
    {
        try
        {
            VendorAdaptor vendorAdaptor = AdaptorSetUpDAO.getVendorAdaptorDetailsByVendorNameAndLocation(VENDOR_NAME_OSEP, INVENTORY_TYPE_DIE_BANK);

            m_username = vendorAdaptor.getUserId();
            m_password = vendorAdaptor.getPassWord();
            m_dataOutputDir = vendorAdaptor.getOutPutDirectory();

            if (m_dataOutputDir != null)
            {
                if (m_dataOutputDir.endsWith("/") || m_dataOutputDir.endsWith("\\"))
                {
                    m_dataOutputDir = m_dataOutputDir + m_username;
                }
                else
                {
                    m_dataOutputDir = m_dataOutputDir + "/" + m_username;
                }
            }

            AdaptorUtils.makeAllAdaptorDirs(m_dataOutputDir);
            m_adaptorLogger = AdaptorUtils.getAdaptorLogger(m_dataOutputDir, VENDOR_NAME_OSEP);
            AdaptorUtils.setLogger( m_adaptorLogger );

        }
        catch (ScalarException se)
        {
            log("ERROR!! ERROR!! ERROR!! Exception while loading OSEP Adaptor Username, Password details from database, Exception: " + se);
            throw se;
        }
    }

    public static void main( String[] args ) throws Exception
    {
        new OSEPDieBankFTPAdaptor().execute();
    }

    public void execute() throws Exception
    {
        try
        {
            m_adaptor_id = AdaptorRunInfo.saveAdaptorLastUpdatedStatus( CONSTANT_ADAPTOR, ADAPTOR_NAME, CONSTANT_SUCCESS, -1);

            //Print the header details
            AdaptorUtils.printHeader(VENDOR_NAME_OSEP + " "+LOCATION_TYPE_DIE_BANK, CONSTANT_ADAPTOR);

            AdaptorUtils.removeOldFiles( m_dataOutputDir, m_adaptorLogger );

            FTPClient ftp = login( HOST, PORT, m_username, m_password );
            log( "Successfully logged in to " + HOST );
            System.out.println( "Successfully logged in to " + HOST );

            // change the directory to data
            ftp.chdir(HOME_DIR);
            log("Remote directory changed to " + HOME_DIR);
            System.out.println("Remote directory changed to " + HOME_DIR);

            //To Down DownLoad the File To Local System at Specepied path
            downloadWIPFiles(ftp);

            // Log out
            logout( ftp );
            log( "\nSuccessfully logged out from OSEP Ftp Site" );
            System.out.println( "\nSuccessfully logged out from OSEP FTP Site" );
        }
        catch ( Exception e )
        {
            AdaptorUtils.removeOldFiles(m_dataOutputDir, m_adaptorLogger);
            AdaptorRunInfo.updatedAdaptorStatus( CONSTANT_FAILURE, m_adaptor_id);
            System.out.println("Exception while trying to connect and read data from " + HOST +" site: " + e);
            log("Exception while trying to connect and read data from " + HOST +" site: " + e);
            e.printStackTrace();
            throw e;
        }
    }
    /**
     *
     * @param host
     * @param port
     * @param m_username
     * @param m_password
     * @return
     * @throws Exception
     */
    private FTPClient login( String host, int port, String m_username, String m_password ) throws Exception
    {
        FTPClient ftp = new FTPClient( host, port );
        ftp.login( m_username, m_password );
        ftp.debugResponses( false );
        ftp.setType( FTPTransferType.BINARY );
        // active does not allows me connect to ftp site even any proxy lies in path.
        ftp.setConnectMode( FTPConnectMode.PASV );
        return ftp;
    }

    private void downloadWIPFiles( FTPClient ftp ) throws Exception
    {
        String[] listings = ftp.dir();

        if ( ( listings == null ) || ( listings.length == 0 ) )
        {
            return;
        }

        byte[] buf                          = null;
        FileOutputStream fileOutputStream   = null;
        String         tempFileName         = null;
        try
        {

            System.out.println( "\tDownloading Wip Standard files...." );

            // Downloading all the vendor files whose date greater than or equal to the last Adaptor Run Time.
            for ( int i = 0; i < listings.length; i++ )
            {
                if ( listings[i].startsWith( FILE_NAME_WIP ) && listings[i].endsWith(FILE_EXTN_CSV))
                {
                    if ( tempFileName == null )
                    {
                        tempFileName = listings[i];
                    }
                   else   //this block not executes // now the yare keeping only one File Every Day
                   {
                        java.util.Date date1 = ftp.modtime( tempFileName );
                        java.util.Date date2 = ftp.modtime( listings[i] );

                        if ( date2.compareTo( date1 ) > 0 )
                        {
                            tempFileName = listings[i];
                        }
                    }
                }
            }
            
            if (   tempFileName != null )
            {
                log( "\ndownloading file " + tempFileName + " to " + m_dataOutputDir + " directory... " );
                if ( m_adaptor_id > 0 )
                {
                    AdaptorRunInfo.saveAdaptorFileInfo( m_adaptor_id , tempFileName.substring(0, tempFileName.indexOf(".") ), FILE_EXTN_CSV, StringUtils.formatDateandTime(DateUtil.getFormattedTimeStamp() ) ) ;
                }
                buf = ftp.get( tempFileName );
                int tempLength = tempFileName.lastIndexOf('.');
                tempFileName = tempFileName.substring( 0, tempLength);
                tempFileName = tempFileName + "_" + AdaptorUtils.getTimeAsString() + FILE_EXTN_CSV;
                fileOutputStream = new FileOutputStream( m_dataOutputDir + "/" + tempFileName, false );
                fileOutputStream.write( buf );
                fileOutputStream.flush();
            }
        }
        catch ( Exception e )
        {
            log( "Exception while downloading......... " + e );
            throw e;
        }
        finally
        {
            if ( fileOutputStream != null )
            {
                try
                {
                    fileOutputStream.flush();
                    fileOutputStream.close();
                }
                catch ( IOException ignore )
                {
                    System.out.println("ignore = " + ignore);
                }
            }
        }
    }
    /**
     *
     * @param ftp
     * @throws Exception
     */
    private void logout( FTPClient ftp ) throws Exception
    {
        if ( ftp == null )
        {
            return;
        }
        try
        {
            ftp.quit();
        }
        catch ( Exception ignore )
        {
            System.out.println( "Exception Occuered While Logging Out From OSEP DIEBANK  Extract FTP Site" + ignore );
            throw ignore;
        }
        ftp = null;
    }

    private void log( String message )
    {
        if ( message == null ) return;

        if ( m_adaptorLogger != null )
        {
            synchronized ( m_adaptorLogger )
            {
                m_adaptorLogger.logDebug( message + LINE_SEPARATOR );
            }
        }
        else
        {
            System.out.println( message );
        }
    }
}
